Task
You work as a first-year analyst in the internal M&A division of Nike. Your manager has requested you prepare an Excel profit and loss (P&L) table for analysis, with details of the earnings before interest and taxes (EBIT) level. The structure should include a revenue breakdown and essential P&L items leading to EBIT. Rename the ‘Operating income’ item to EBIT in your table.
Please create a new sheet with the following structure using professional formatting:

Task 1_Formatting.png
Note: Keep the leading spaces like that in the source file because they might be needed for lookup functions later.
Bloomberg data_Source
